create  table jms_dm.dm_door_sign_rate_dt 
(
date_time  date COMMENT '日期分区',
end_agent_code varchar(100) COMMENT '代理区' ,
end_agent_name varchar(100) COMMENT '代理区' ,
final_sign_network_code varchar(100) COMMENT '网点' ,
final_sign_network_name varchar(100) COMMENT '网点' ,
aging_sign bigint COMMENT '时效签收票数' ,
door_sign bigint COMMENT '送货上门票数' ,
xusign bigint COMMENT '虚假签收票数' ,
door_sign_rate decimal(16,4) COMMENT '送货上门率' ,
stage_sign bigint COMMENT '送入驿站票数',
expand1 bigint COMMENT '预留字段1',
expand2 bigint COMMENT '预留字段2',
expand3 bigint COMMENT '预留字段3',
expand4 bigint COMMENT '预留字段4',
expand5 bigint COMMENT '预留字段5'
)
ENGINE=OLAP
DUPLICATE KEY(date_time,end_agent_code,end_agent_name)
comment '送货上门率导数'
PARTITION BY RANGE (date_time) ( 
   START ("2022-09-18") END ("2022-11-17") EVERY (INTERVAL 1 day))DISTRIBUTED BY HASH(final_sign_network_code) BUCKETS 2
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "2",
"in_memory" = "false",
"storage_format" = "V2"
);